
cd "C:\Users\sertsios\Dropbox\LPSU replication package RFS\Replication\Log files\Main Tables"
clear
log using Table6.txt, text replace

***OROA interactions
clear
cd "C:\Users\sertsios\Dropbox\LPSU replication package RFS\Data"
use LPSU_MainSample_Sep2024, replace
set matsize 10000
cd "C:\Users\sertsios\Dropbox\LPSU replication package RFS\Tables"

***Set of fixed effects
egen sic1year=group(sic1 year)
qui tabulate sic1year, generate(dsic1year)
egen month_post= group(month post)
qui tabulate month_post, generate(dmonth)
qui tabulate year_around_ipo, generate(deventyear) 


***Setting the sample to the IV sample (dropping obs colinear  with FEs)
set more off
qui xtivreg2 wroa (IPO=instrument) deventyear2 deventyear3 deventyear4 deventyear5 dsic1year* dmonth* , fe first cluster(id) partial(deventyear2 deventyear3 deventyear4 deventyear5 dsic1year* dmonth*)
gen sample_IV=e(sample) 
keep if sample_IV==1
**Dropping firms for which OROA only has one observation
bysort id: egen count=count(year)
drop if count==1 

eststo clear  

**Table 6
set more off
eststo:qui xtivreg2 wroa (IPO IPO_fin_dep_eu_hi=instrument instrument_fin_dep_eu_hi) deventyear2 deventyear3 deventyear4 deventyear5   dsic1year* dmonth*, fe first cluster(id) partial(deventyear2 deventyear3 deventyear4 deventyear5 dsic1year* dmonth*)
outreg2 using Table_interactions.xls, keep(IPO IPO_fin_dep_eu_hi) sortvar(IPO IPO_fin_dep_eu_hi   IPO_small_s IPO_Y IPO_high_self) tex(frag) excel bdec(3) nocons nor2 label ///
 addtext(Firm FE, Yes, Event year FE, Yes, SIC x calendar year FE, Yes, IPO month x Post FE, Yes,Regression, Second stage,Instruments,Pre-IPO ret>0 & Pre-IPO ret>0 x High Fin Dep) replace

set more off
eststo:qui xtivreg2 wroa (IPO IPO_small_s =instrument instrument_small_s ) deventyear2 deventyear3 deventyear4 deventyear5   dsic1year* dmonth*, fe first cluster(id) partial(deventyear2 deventyear3 deventyear4 deventyear5 dsic1year* dmonth*)
outreg2 using Table_interactions.xls, keep(IPO IPO_small_s ) sortvar(IPO IPO_fin_dep_eu_hi   IPO_small_s IPO_Y IPO_high_self) tex(frag) excel bdec(3) nocons nor2 label ///
 addtext(Firm FE, Yes, Event year FE, Yes, SIC x calendar year FE, Yes, IPO month x Post FE, Yes,Regression, Second stage,Instruments,Pre-IPO ret>0 & Pre-IPO ret>0 x Small)

set more off
eststo:qui xtivreg2 wroa (IPO IPO_Y =instrument instrument_Y ) deventyear2 deventyear3 deventyear4 deventyear5   dsic1year* dmonth*, fe first cluster(id) partial(deventyear2 deventyear3 deventyear4 deventyear5 dsic1year* dmonth*)
outreg2 using Table_interactions.xls, keep(IPO IPO_Y ) sortvar(IPO IPO_fin_dep_eu_hi   IPO_small_s IPO_Y IPO_high_self) tex(frag) excel bdec(3) nocons nor2 label ///
 addtext(Firm FE, Yes, Event year FE, Yes, SIC x calendar year FE, Yes, IPO month x Post FE, Yes,Regression, Second stage,Instruments,Pre-IPO ret>0 & Pre-IPO ret>0 x Young)
 
set more off
eststo:qui xtivreg2 wroa (IPO IPO_high_self=instrument instrument_high_self) deventyear2 deventyear3 deventyear4 deventyear5   dsic1year* dmonth*, fe first cluster(id) partial(deventyear2 deventyear3 deventyear4 deventyear5 dsic1year* dmonth*)
outreg2 using Table_interactions.xls, keep(IPO IPO_high_self ) sortvar(IPO IPO_fin_dep_eu_hi   IPO_small_s IPO_Y IPO_high_self) tex(frag) excel bdec(3) nocons nor2 label ///
 addtext(Firm FE, Yes, Event year FE, Yes, SIC x calendar year FE, Yes, IPO month x Post FE, Yes,Regression, Second stage,Instruments,Pre-IPO ret>0 & Pre-IPO ret>0 x High anti-sd) 
 
set more off
eststo:qui xtivreg2 wroa (IPO IPO_fin_dep_eu_hi   IPO_small_s IPO_Y IPO_high_self=instrument instrument_fin_dep_eu_hi instrument_small_s instrument_Y  instrument_high_self) ///
 deventyear2 deventyear3 deventyear4 deventyear5   dsic1year* dmonth*, fe first cluster(id) partial(deventyear2 deventyear3 deventyear4 deventyear5 dsic1year* dmonth*)
outreg2 using Table_interactions.xls, keep(IPO IPO_fin_dep_eu_hi   IPO_small_s IPO_Y IPO_high_self ) sortvar(IPO IPO_fin_dep_eu_hi   IPO_small_s IPO_Y IPO_high_self) tex(frag) excel bdec(3) nocons nor2 label ///
 addtext(Firm FE, Yes, Event year FE, Yes, SIC x calendar year FE, Yes, IPO month x Post FE, Yes,Regression, Second stage,Instruments,Pre-IPO ret>0 & Pre-IPO ret>0 x All)  
 
 
esttab,   keep(IPO IPO_fin_dep_eu_hi IPO_small_s IPO_Y IPO_high_self) order(IPO IPO_fin_dep_eu_hi IPO_small_s IPO_Y IPO_high_self) ///
 label se b(%9.3f) se(%9.3f) nor2 star(* 0.1 ** 0.05 *** 0.01) addnotes(Firm FE, Yes, Event year FE, Yes, SIC x calendar year FE, Yes, IPO month x Post FE, Yes) 
 
eststo clear  
 
cd "C:\Users\sertsios\Dropbox\LPSU replication package RFS\Replication\Log files\Main Tables"
log close 
 
 
 
 
 
 
 
 
 

 